Bill of Materials Tables
Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.
tblBmAcctCode -- BM Account Code table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
GLAcctCode | pGLAcctCode | 2 | |||
GLInventoryLabour | pGlAcct | 40 | |||
GLInventoryAppliedLabour | pGlAcct | 40 | |||
CF | xml | -1 |
tblBmBom -- BM Bill of Materials table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BmBomId | int | 4 | |||
BmItemId | pItemID | 24 | |||
BmLocId | pLocID | 10 | |||
Descr | nvarchar | 35 | |||
LaborCost | pDec | 13 | 0 | ||
UsrFldTxt1 | nvarchar | 12 | |||
UsrFldTxt2 | nvarchar | 12 | |||
UsrFldTxt3 | nvarchar | 12 | |||
UsrFldTxt4 | nvarchar | 12 | |||
UsrFldTxt5 | nvarchar | 12 | |||
UsrFldCst1 | nvarchar | 12 | |||
UsrFldCst2 | nvarchar | 12 | |||
UsrFldCst3 | nvarchar | 12 | |||
UsrFldCst4 | nvarchar | 12 | |||
UsrFldCst5 | nvarchar | 12 | |||
Uom | pUom | 5 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBmBomDetail -- BM Bill of Materials Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BmBomId | int | 4 | |||
BmDetailType | tinyint | 1 | Item / Subassembly Flag | 1 = Item, 2 = Sub | |
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
Quantity | pDec | 13 | |||
Uom | pUom | 5 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBmBomDetailHist -- BM Bill of Materials Detail History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Counter | int | 4 | |||
HistSeqNum | int | 4 | |||
BmBomId | int | 4 | |||
BmDetailType | tinyint | 1 | Item / Subassembly Flag | 1 = Item, 2 = Sub | |
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
Quantity | pDec | 13 | |||
Uom | pUom | 5 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBmBomHist -- BM Bill of Materials History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
HistSeqNum | int | 4 | |||
BmBomId | int | 4 | |||
BmItemId | pItemID | 24 | |||
BmLocId | pLocID | 10 | |||
Descr | nvarchar | 35 | |||
Status | tinyint | 1 | |||
LaborCost | pDec | 13 | |||
UsrFldTxt1 | nvarchar | 12 | |||
UsrFldTxt2 | nvarchar | 12 | |||
UsrFldTxt3 | nvarchar | 12 | |||
UsrFldTxt4 | nvarchar | 12 | |||
UsrFldTxt5 | nvarchar | 12 | |||
UsrFldCst1 | nvarchar | 12 | |||
UsrFldCst2 | nvarchar | 12 | |||
UsrFldCst3 | nvarchar | 12 | |||
UsrFldCst4 | nvarchar | 12 | |||
UsrFldCst5 | nvarchar | 12 | |||
Update | nvarchar | 9 | |||
UserId | pUserID | 20 | |||
Uom | pUom | 5 | |||
Period | smallint | 2 | |||
Year | smallint | 2 | |||
UpdateDate | datetime | 8 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBmBomInst -- BM Bill of Materials Instructions table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
BmBomId | int | 4 | |||
Instructions | text | 16 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBmKitHistDetail -- BM Kit Detail History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Counter | int | 4 | |||
HistSeqNum | int | 4 | |||
EntryNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
ItemType | tinyint | 1 | 0 | Item Type | 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item |
LottedYN | bit | 1 | 0 | ||
Uom | pUom | 5 | |||
ConvFactor | pDec | 13 | -1 | ||
Qty | pDec | 13 | 0 | ||
UnitCost | pDec | 13 | 0 | ||
UnitPrice | pDec | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBmKitHistLot -- BM Kit Lot History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Counter | int | 4 | |||
HistSeqNum | int | 4 | |||
EntryNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
QtyTrans | pDec | 13 | 0 | ||
CostUnit | pDec | 13 | 0 | ||
PriceUnit | pDec | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBmKitHistSer -- BM Kit Serial Number History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
Counter | int | 4 | |||
HistSeqNum | int | 4 | 0 | ||
EntryNumber | int | 4 | 0 | ||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
CostUnit | pDec | 13 | 0 | ||
PriceUnit | pDec | 13 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ExtLocAID | varchar | 10 | |||
ExtLocBID | varchar | 10 |
tblBmKitHistSumm -- BM Kit Summary History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
HistSeqNum | int | 4 | |||
BmBomId | int | 4 | |||
ItemId | nvarchar | 24 | |||
LocId | nvarchar | 10 | |||
SumYear | smallint | 2 | 0 | ||
SumPeriod | smallint | 2 | 0 | ||
GLPeriod | smallint | 2 | 0 | ||
BatchId | nvarchar | 10 | |||
TransId | nvarchar | 10 | |||
SrceID | nvarchar | 10 | |||
Uom | nvarchar | 5 | |||
ConvFactor | pDec | 13 | -1 | ||
Qty | pDec | 13 | 0 | ||
Cost | pDec | 13 | 0 | ||
Price | pDec | 13 | 0 | ||
CustId | nvarchar | 10 | |||
TransDate | datetime | 8 | |||
Counter | int | 4 | |||
InvcNum | nvarchar | 15 | |||
CF | xml | -1 | |||
ts | timestamp | 8 |
tblBmWorkOrder -- BM Work Order table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
EntryNum | int | 4 | (-1) | ||
TransDate | datetime | 8 | getdate() | ||
WorkType | tinyint | 1 | -1 | Work Order Type | 1 = Build, 2 = Unbuild |
Status | tinyint | 1 | 0 | Work Order Status | 0 = Issued, 1 = Confirmed |
PrintedYn | bit | 1 | 0 | ||
BmBomId | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
ItemType | tinyint | 1 | Item Type | 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item, 11 = Lotted Inventory Item, 21 = Lotted Serialized | |
BuildUOM | pUom | 5 | |||
BuildQty | pDec | 13 | 0 | ||
ActualQty | pDec | 13 | 0 | ||
LaborCost | pDec | 13 | 0 | ||
UnitCost | pDec | 13 | 0 | ||
ConvFactor | pDec | 13 | -1 | ||
GLPeriod | smallint | 2 | 0 | ||
GlYear | smallint | 2 | 0 | ||
SumHistPeriod | smallint | 2 | 0 | ||
QtySeqNum | int | 4 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
WorkUser | pUserID | 20 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*ExtLocA | int | ||||
*ExtLocB | int | ||||
*QtySeqNum_Ext | int | ||||
*QtyStatus | int |
tblBmWorkOrderDetail -- BM Work Order Detail table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
EntryNum | int | 4 | 0 | ||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
ItemType | tinyint | 1 | Item Type | 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item, 11 = Lotted Inventory Item, 21 = Lotted Serialized | |
OriCompQty | pDec | 13 | 0 | ||
EstQty | pDec | 13 | 0 | ||
ActQty | pDec | 13 | 0 | ||
Uom | pUom | 5 | |||
ConvFactor | pDec | 13 | -1 | ||
UnitCost | pDec | 13 | 0 | ||
QtySeqNum | int | 4 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*ExtLocA | int | ||||
*ExtLocB | int | ||||
*QtySeqNum_Ext | int | ||||
*QtyStatus | int |
tblBmWorkOrderHist -- BM Work Order History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | 0 | ||
TransId | pTransID | 8 | |||
EntryNum | int | 4 | (-1) | ||
TransDate | datetime | 8 | getdate() | ||
WorkType | tinyint | 1 | -1 | Work Order Type | 1 = Build, 2 = Unbuild |
Status | tinyint | 1 | 0 | Work Order Status | 0 = Issued, 1 = Confirmed |
PrintedYn | bit | 1 | 0 | ||
BmBomId | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
ItemType | tinyint | 1 | Item Type | 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item, 11 = Lotted Inventory Item, 21 = Lotted Serialized | |
BuildUOM | pUom | 5 | |||
BuildQty | pDec | 13 | 0 | ||
ActualQty | pDec | 13 | 0 | ||
LaborCost | pDec | 13 | 0 | ||
UnitCost | pDec | 13 | 0 | ||
ConvFactor | pDec | 13 | -1 | ||
GLPeriod | smallint | 2 | 0 | ||
GlYear | smallint | 2 | 0 | ||
SumHistPeriod | smallint | 2 | 0 | ||
QtySeqNum | int | 4 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
WorkUser | pUserID | 20 | |||
Descr | nvarchar | 35 | |||
UomBase | pUom | 5 | |||
ItemStatus | tinyint | 1 | Item Status | 1 = Active, 2 = Discontinued, 3 = Superseded, 4 = Obsolete | |
ItemLocStatus | tinyint | 1 | Item Location Status | 1 = Active, 2 = Discontinued, 3 = Superseded, 4 = Obsolete | |
GLAcctCode | pGLAcctCode | 2 | |||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*ExtLocAID | nvarchar | 10 | |||
*ExtLocBID | nvarchar | 10 | |||
*QtySeqNum_Ext | int | ||||
*QtyStatus | int |
tblBmWorkOrderHistDetail -- BM Work Order Detail History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | 0 | ||
TransId | pTransID | 8 | |||
EntryNum | int | 4 | 0 | ||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
ItemType | tinyint | 1 | Item Type | 0 = Non-Inventory Item, 1 = Inventory Item, 2 = Serialized Item, 3 = Service Item, 11 = Lotted Inventory Item, 21 = Lotted Serialized | |
OriCompQty | pDec | 13 | 0 | ||
EstQty | pDec | 13 | 0 | ||
ActQty | pDec | 13 | 0 | ||
Uom | pUom | 5 | |||
ConvFactor | pDec | 13 | -1 | ||
UnitCost | pDec | 13 | 0 | ||
QtySeqNum | int | 4 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*ExtLocAID | nvarchar | 10 | |||
*ExtLocBID | nvarchar | 10 | |||
*QtySeqNum_Ext | int | ||||
*QtyStatus | int |
tblBmWorkOrderHistLot -- BM Work Order Lot History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | 0 | ||
TransId | pTransID | 8 | |||
EntryNum | int | 4 | 0 | ||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
QtyOrder | pDec | 13 | 0 | ||
QtyFilled | pDec | 13 | 0 | ||
QtyBkord | pDec | 13 | 0 | ||
CostUnit | pDec | 13 | 0 | ||
CostUnitFgn | pDec | 13 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
Cmnt | nvarchar | 35 | |||
QtySeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*ExtLocAID | nvarchar | 10 | |||
*ExtLocBID | nvarchar | 10 | |||
*QtySeqNum_Ext | int | ||||
*QtyStatus | int |
tblBmWorkOrderHistSer -- BM Work Order Serial Number History table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
PostRun | pPostRun | 14 | 0 | ||
TransId | pTransID | 8 | |||
EntryNum | int | 4 | 0 | ||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
CostUnit | pDec | 13 | 0 | ||
CostUnitFgn | pDec | 13 | 0 | ||
PriceUnit | pDec | 13 | 0 | ||
PriceUnitFgn | pDec | 13 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
Cmnt | nvarchar | 35 | |||
QtySeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ExtLocAID | varchar | 10 | |||
ExtLocBID | varchar | 10 | |||
*CostUnitACV | pDec | 13 | |||
*QtyStatus | int |
tblBmWorkOrderLot -- BM Work Order Lot table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
EntryNum | int | 4 | 0 | ||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
QtyOrder | pDec | 13 | 0 | ||
QtyFilled | pDec | 13 | 0 | ||
QtyBkord | pDec | 13 | 0 | ||
CostUnit | pDec | 13 | 0 | ||
CostUnitFgn | pDec | 13 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
Cmnt | nvarchar | 35 | |||
QtySeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
*ExtLocA | int | ||||
*ExtLocB | int | ||||
*QtySeqNum_Ext | int | ||||
*QtyStatus | int |
tblBmWorkOrderSer -- BM Work Order Serial Number table
Column Name | Column Type | Length | Default Value | Description | Enumeration |
---|---|---|---|---|---|
TransId | pTransID | 8 | |||
EntryNum | int | 4 | 0 | ||
SeqNum | int | 4 | |||
ItemId | pItemID | 24 | |||
LocId | pLocID | 10 | |||
LotNum | pLotNum | 16 | |||
SerNum | pSerNum | 35 | |||
CostUnit | pDec | 13 | 0 | ||
CostUnitFgn | pDec | 13 | 0 | ||
PriceUnit | pDec | 13 | 0 | ||
PriceUnitFgn | pDec | 13 | 0 | ||
HistSeqNum | int | 4 | 0 | ||
Cmnt | nvarchar | 35 | |||
QtySeqNum | int | 4 | 0 | ||
CF | xml | -1 | |||
ts | timestamp | 8 | |||
ExtLocA | int | 4 | |||
ExtLocB | int | 4 | |||
*QtyStatus | int |